﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ddbAssignmentTrackerDataSet" targetNamespace="http://tempuri.org/ddbAssignmentTrackerDataSet.xsd" xmlns:mstns="http://tempuri.org/ddbAssignmentTrackerDataSet.xsd" xmlns="http://tempuri.org/ddbAssignmentTrackerDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ddbAssignmentTrackerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ddbAssignmentTrackerConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.StudentAssignmentTracker.My.MySettings.GlobalReference.Default.ddbAssignmentTrackerConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAssignmentsTableAdapter" GeneratorDataComponentClassName="tblAssignmentsTableAdapter" Name="tblAssignments" UserDataComponentName="tblAssignmentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ddbAssignmentTrackerConnectionString (MySettings)" DbObjectName="dbo.tblAssignments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblAssignments] WHERE (([assignmentID] = @Original_assignmentID) AND ([className] = @Original_className) AND ([assignmentTitle] = @Original_assignmentTitle) AND ((@IsNull_assignmentDueDate = 1 AND [assignmentDueDate] IS NULL) OR ([assignmentDueDate] = @Original_assignmentDueDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_assignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="assignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_className" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="className" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_assignmentTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="assignmentTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_assignmentDueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="assignmentDueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_assignmentDueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="assignmentDueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblAssignments] ([assignmentID], [className], [assignmentTitle], [assignmentDescription], [assignmentDueDate], [notes]) VALUES (@assignmentID, @className, @assignmentTitle, @assignmentDescription, @assignmentDueDate, @notes);
SELECT assignmentID, className, assignmentTitle, assignmentDescription, assignmentDueDate, notes FROM tblAssignments WHERE (assignmentID = @assignmentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@assignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="assignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@className" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="className" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@assignmentTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="assignmentTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@assignmentDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="assignmentDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@assignmentDueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="assignmentDueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@notes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        assignmentID, className, assignmentTitle, assignmentDescription, assignmentDueDate, notes
FROM            tblAssignments</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblAssignments] SET [assignmentID] = @assignmentID, [className] = @className, [assignmentTitle] = @assignmentTitle, [assignmentDescription] = @assignmentDescription, [assignmentDueDate] = @assignmentDueDate, [notes] = @notes WHERE (([assignmentID] = @Original_assignmentID) AND ([className] = @Original_className) AND ([assignmentTitle] = @Original_assignmentTitle) AND ((@IsNull_assignmentDueDate = 1 AND [assignmentDueDate] IS NULL) OR ([assignmentDueDate] = @Original_assignmentDueDate)));
SELECT assignmentID, className, assignmentTitle, assignmentDescription, assignmentDueDate, notes FROM tblAssignments WHERE (assignmentID = @assignmentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@assignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="assignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@className" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="className" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@assignmentTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="assignmentTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@assignmentDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="assignmentDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@assignmentDueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="assignmentDueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@notes" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_assignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="assignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_className" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="className" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_assignmentTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="assignmentTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_assignmentDueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="assignmentDueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_assignmentDueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="assignmentDueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="assignmentID" DataSetColumn="assignmentID" />
              <Mapping SourceColumn="className" DataSetColumn="className" />
              <Mapping SourceColumn="assignmentTitle" DataSetColumn="assignmentTitle" />
              <Mapping SourceColumn="assignmentDescription" DataSetColumn="assignmentDescription" />
              <Mapping SourceColumn="assignmentDueDate" DataSetColumn="assignmentDueDate" />
              <Mapping SourceColumn="notes" DataSetColumn="notes" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ddbAssignmentTrackerDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ddbAssignmentTrackerDataSet" msprop:Generator_UserDSName="ddbAssignmentTrackerDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblAssignments" msprop:Generator_TableClassName="tblAssignmentsDataTable" msprop:Generator_TableVarName="tabletblAssignments" msprop:Generator_TablePropName="tblAssignments" msprop:Generator_RowDeletingName="tblAssignmentsRowDeleting" msprop:Generator_UserTableName="tblAssignments" msprop:Generator_RowChangingName="tblAssignmentsRowChanging" msprop:Generator_RowEvHandlerName="tblAssignmentsRowChangeEventHandler" msprop:Generator_RowDeletedName="tblAssignmentsRowDeleted" msprop:Generator_RowEvArgName="tblAssignmentsRowChangeEvent" msprop:Generator_RowChangedName="tblAssignmentsRowChanged" msprop:Generator_RowClassName="tblAssignmentsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="assignmentID" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnassignmentID" msprop:Generator_ColumnPropNameInRow="assignmentID" msprop:Generator_ColumnPropNameInTable="assignmentIDColumn" msprop:Generator_UserColumnName="assignmentID" type="xs:int" />
              <xs:element name="className" msprop:Generator_ColumnVarNameInTable="columnclassName" msprop:Generator_ColumnPropNameInRow="className" msprop:Generator_ColumnPropNameInTable="classNameColumn" msprop:Generator_UserColumnName="className">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="assignmentTitle" msprop:Generator_ColumnVarNameInTable="columnassignmentTitle" msprop:Generator_ColumnPropNameInRow="assignmentTitle" msprop:Generator_ColumnPropNameInTable="assignmentTitleColumn" msprop:Generator_UserColumnName="assignmentTitle">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="assignmentDescription" msprop:Generator_ColumnVarNameInTable="columnassignmentDescription" msprop:Generator_ColumnPropNameInRow="assignmentDescription" msprop:Generator_ColumnPropNameInTable="assignmentDescriptionColumn" msprop:Generator_UserColumnName="assignmentDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="assignmentDueDate" msprop:Generator_ColumnVarNameInTable="columnassignmentDueDate" msprop:Generator_ColumnPropNameInRow="assignmentDueDate" msprop:Generator_ColumnPropNameInTable="assignmentDueDateColumn" msprop:Generator_UserColumnName="assignmentDueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="notes" msprop:Generator_ColumnVarNameInTable="columnnotes" msprop:Generator_ColumnPropNameInRow="notes" msprop:Generator_ColumnPropNameInTable="notesColumn" msprop:Generator_UserColumnName="notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblAssignments" />
      <xs:field xpath="mstns:assignmentID" />
    </xs:unique>
  </xs:element>
</xs:schema>